Paul Newcome
Paul Newcome
-
Re: Adding One More Criteria to Working COLLECT Formula
Double check your cross sheet references are all of the same size and shape. Sometimes things can be a little slow on the back-end and change a full column reference to a single cell reference if you…1 · -
Re: Invalid Value Error on Dates (even when the column types are all DATE fields)
Here is another way of doing it that may be a little easier to modify. =IF([Affiliation Date]@row <> "", IFERROR(DATE(YEAR([Affiliation Date]@row), MONTH([Affiliation Date]@row) - 6, …1 · -
Re: Need a conditional formula to automate status column based on values in date columns
Another option would be along the lines of... =IF(ISDATE(End@row), "Complete", IF(ISDATE(Start@row), "In Progress", "Not Started"))1 · -
Re: Pause "Days in Progress" counter
Building off of the two date columns for on hold then off of hold, you could just do a basic subtraction of the two dates to get the duration of on hold and then subtract that from the final result o…1 · -
Re: Whats wrong with this nested if and vlookup formula?
Happy to help. 👍️ A quick tip: If you catch yourself repeating the same pieces of a formula over and over again with the only difference being a single variable based on an IF, you can nest the IF in…2 ·
